﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsorder" targetNamespace="http://tempuri.org/dsorder.xsd" xmlns:mstns="http://tempuri.org/dsorder.xsd" xmlns="http://tempuri.org/dsorder.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="tailoringmngConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="tailoringmngConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Tailoring.Properties.Settings.GlobalReference.Default.tailoringmngConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" GeneratorDataComponentClassName="DataTable1TableAdapter" Name="DataTable1" UserDataComponentName="DataTable1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="tailoringmngConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        TOP (100) PERCENT tblclientinfo.clientId AS ID, tblclientinfo.name AS Name, tblclientinfo.mobile AS Mobile, tblclientinfo.address AS Address, tblorder.deliveryDate AS DDate, tblorder.dayToReturn, 
                         tblorder.nubmerOfCloths, tblorder.orderId AS OrderID, tblspecification.specificationId, tblaccount.account AS actId, tblaccount.clientId AS act_cid, tblaccount.orderId AS act_oid, tblaccount.totalAmount AS Tamount, 
                         tblaccount.amountRece AS amountRec, tblaccount.amountBal AS bal
FROM            tblclientinfo INNER JOIN
                         tblorder ON tblclientinfo.clientId = tblorder.clientId INNER JOIN
                         tblspecification ON tblorder.orderId = tblspecification.orderId AND tblorder.orderId = tblspecification.orderId INNER JOIN
                         tblaccount ON tblclientinfo.clientId = tblaccount.clientId
WHERE        (tblclientinfo.clientId = @id) AND (tblorder.orderId = @oid) AND (tblaccount.orderId = @oid)
ORDER BY DDate DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="clientId" DataSourceName="tailoringmng.dbo.tblclientinfo" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="oid" ColumnName="orderId" DataSourceName="tailoringmng.dbo.tblorder" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@oid" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="OrderID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Mobile" DataSetColumn="Mobile" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="DDate" DataSetColumn="DDate" />
              <Mapping SourceColumn="OrderID" DataSetColumn="OrderID" />
              <Mapping SourceColumn="specificationId" DataSetColumn="specificationId" />
              <Mapping SourceColumn="act_cid" DataSetColumn="act_cid" />
              <Mapping SourceColumn="act_oid" DataSetColumn="act_oid" />
              <Mapping SourceColumn="Tamount" DataSetColumn="Tamount" />
              <Mapping SourceColumn="amountRec" DataSetColumn="amountRec" />
              <Mapping SourceColumn="bal" DataSetColumn="bal" />
              <Mapping SourceColumn="dayToReturn" DataSetColumn="dayToReturn" />
              <Mapping SourceColumn="nubmerOfCloths" DataSetColumn="nubmerOfCloths" />
              <Mapping SourceColumn="actId" DataSetColumn="actId" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsorder" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsorder" msprop:Generator_UserDSName="dsorder">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="DataTable1" msprop:Generator_TableClassName="DataTable1DataTable" msprop:Generator_TableVarName="tableDataTable1" msprop:Generator_TablePropName="DataTable1" msprop:Generator_RowDeletingName="DataTable1RowDeleting" msprop:Generator_RowChangingName="DataTable1RowChanging" msprop:Generator_RowEvHandlerName="DataTable1RowChangeEventHandler" msprop:Generator_RowDeletedName="DataTable1RowDeleted" msprop:Generator_UserTableName="DataTable1" msprop:Generator_RowChangedName="DataTable1RowChanged" msprop:Generator_RowEvArgName="DataTable1RowChangeEvent" msprop:Generator_RowClassName="DataTable1Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mobile" msprop:Generator_ColumnVarNameInTable="columnMobile" msprop:Generator_ColumnPropNameInRow="Mobile" msprop:Generator_ColumnPropNameInTable="MobileColumn" msprop:Generator_UserColumnName="Mobile" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_UserColumnName="Address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DDate" msprop:Generator_ColumnVarNameInTable="columnDDate" msprop:Generator_ColumnPropNameInRow="DDate" msprop:Generator_ColumnPropNameInTable="DDateColumn" msprop:Generator_UserColumnName="DDate" type="xs:dateTime" />
              <xs:element name="OrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnOrderID" msprop:Generator_ColumnPropNameInRow="OrderID" msprop:Generator_ColumnPropNameInTable="OrderIDColumn" msprop:Generator_UserColumnName="OrderID" type="xs:int" />
              <xs:element name="specificationId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnspecificationId" msprop:Generator_ColumnPropNameInRow="specificationId" msprop:Generator_ColumnPropNameInTable="specificationIdColumn" msprop:Generator_UserColumnName="specificationId" type="xs:int" />
              <xs:element name="act_cid" msprop:Generator_ColumnVarNameInTable="columnact_cid" msprop:Generator_ColumnPropNameInRow="act_cid" msprop:Generator_ColumnPropNameInTable="act_cidColumn" msprop:Generator_UserColumnName="act_cid" type="xs:int" />
              <xs:element name="act_oid" msprop:Generator_ColumnVarNameInTable="columnact_oid" msprop:Generator_ColumnPropNameInRow="act_oid" msprop:Generator_ColumnPropNameInTable="act_oidColumn" msprop:Generator_UserColumnName="act_oid" type="xs:int" />
              <xs:element name="Tamount" msprop:Generator_ColumnVarNameInTable="columnTamount" msprop:Generator_ColumnPropNameInRow="Tamount" msprop:Generator_ColumnPropNameInTable="TamountColumn" msprop:Generator_UserColumnName="Tamount" type="xs:int" minOccurs="0" />
              <xs:element name="amountRec" msprop:Generator_ColumnVarNameInTable="columnamountRec" msprop:Generator_ColumnPropNameInRow="amountRec" msprop:Generator_ColumnPropNameInTable="amountRecColumn" msprop:Generator_UserColumnName="amountRec" type="xs:int" minOccurs="0" />
              <xs:element name="bal" msprop:Generator_ColumnVarNameInTable="columnbal" msprop:Generator_ColumnPropNameInRow="bal" msprop:Generator_ColumnPropNameInTable="balColumn" msprop:Generator_UserColumnName="bal" type="xs:int" minOccurs="0" />
              <xs:element name="dayToReturn" msprop:Generator_ColumnVarNameInTable="columndayToReturn" msprop:Generator_ColumnPropNameInRow="dayToReturn" msprop:Generator_ColumnPropNameInTable="dayToReturnColumn" msprop:Generator_UserColumnName="dayToReturn" type="xs:int" />
              <xs:element name="nubmerOfCloths" msprop:Generator_ColumnVarNameInTable="columnnubmerOfCloths" msprop:Generator_ColumnPropNameInRow="nubmerOfCloths" msprop:Generator_ColumnPropNameInTable="nubmerOfClothsColumn" msprop:Generator_UserColumnName="nubmerOfCloths" type="xs:int" />
              <xs:element name="actId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnactId" msprop:Generator_ColumnPropNameInRow="actId" msprop:Generator_ColumnPropNameInTable="actIdColumn" msprop:Generator_UserColumnName="actId" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DataTable1" />
      <xs:field xpath="mstns:ID" />
      <xs:field xpath="mstns:OrderID" />
      <xs:field xpath="mstns:specificationId" />
    </xs:unique>
  </xs:element>
</xs:schema>